package com.hwua.tonyshop.criteria;
	
import com.slkj.autocode.entity.Page;
import com.hwua.tonyshop.entity.pojo.BackUser;

/**
* 
* @author sunny Yang [杨松彦]
* @QQ 550358261
* @date 2018-04-16
* @discribe
* >、<、>=、<=、=、!=、like、
* is null、is not null、in、not in
*
*/
public class BackUserCriteria extends BackUser{
	/**
	* 版本号
	*/
	private static final long serialVersionUID = 1L;
	private String groupBy123;//分组
	private String having123;//分组过滤
	private String orderBy123;//排序
	private Page page123;
	private String condition123="";//纯条件
	private String selectCondition123;//查询条件
	private String sql123;
	private BackUser backUser;
	private String feid123;//字段用于统计查询时设置

	public BackUserCriteria() {

	}
	public String getFeid123() {
		return feid123;
	}
	public void setFeid123(String feid) {
		this.feid123 = feid;
	}
	public BackUser getBackUser() {
		return backUser;
	}
	public void setBackUser(BackUser backUser) {
		this.backUser = backUser;
		initBackUser(backUser);
	}

	public String getSql123() {
		return sql123;
	}

	public void setSql123(String sql123) {
		this.sql123 = sql123;
	}

	public String getSelectCondition123() {
		if(selectCondition123==null){
			if(condition123.trim().length()>0){
				condition123 = "where "+condition123;
			}
			selectCondition123 = condition123;
			if(groupBy123!=null){
				selectCondition123 += " group by "+groupBy123+" ";
			}
			if(having123!=null){
				selectCondition123 += "having "+having123+" ";
			}
			if(orderBy123!=null){
				selectCondition123 += "order by "+orderBy123+" ";
			}
			if(page123!=null){
				selectCondition123 += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
			}
			selectCondition123 = selectCondition123.trim();
		}
		System.out.println("查询条件："+selectCondition123);
		return selectCondition123;
	}
	public void setSelectCondition123(String selectCondition) {
		this.selectCondition123 = selectCondition;
	}
	public String getCondition123() {
		System.out.println("纯条件："+condition123);
		return condition123;
	}
	public void setCondition123(String condition) {
		this.condition123 = condition;
	}
	public BackUserCriteria page(Page value){
		page123 = value;
		return this;
	}
	public BackUserCriteria groupBy(String value){
		groupBy123 = value;
		return this;
	}
	public BackUserCriteria having(String value){
		having123 = value;
		return this;
	}
	public BackUserCriteria orderBy(String value){
		orderBy123 = value;
		return this;
	}

	/*public String getSqlAll(String tableName){
		String sql = "";
		if("where ".equals(condition123)){
			sql = "select * from `"+tableName+"` ";
		}else{
			sql = "select * from `"+tableName+"` "+condition123+" ";
		}
		if(groupBy123!=null){
			sql += sql+" group by "+groupBy123+" ";
		}
		if(having123!=null){
			sql += "having "+having123+" ";
		}
		if(orderBy123!=null){
			sql += "order by "+orderBy123+" ";
		}
		if(page123!=null){
			sql += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
		}
		sql = sql.trim();
		return sql; 
	}*/

/************以下为纯条件的拼接*******************/

	public BackUserCriteria andIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `id` is null";
			}else{
				condition123 += "`id` is null";
			}
		return this;
	}
	public BackUserCriteria orIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is null";
		}else{
			condition123 += "`id` is null";
		}
		return this;
	}
	public BackUserCriteria andIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public BackUserCriteria orIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public BackUserCriteria andIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public BackUserCriteria andIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}
	public BackUserCriteria orIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}

	public BackUserCriteria andUserNameEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`='"+userName+"' ";
			}else{
				condition123 += "`user_name`='"+userName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orUserNameEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`='"+userName+"' ";
			}else{
				condition123 += "`user_name`='"+userName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andUserNameNotEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`!='"+userName+"' ";
			}else{
				condition123 += "`user_name`!='"+userName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orUserNameNotEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`!='"+userName+"' ";
			}else{
				condition123 += "`user_name`!='"+userName+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andUserNameGreaterThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`>'"+userName+"' ";
			}else{
				condition123 += "`user_name`>'"+userName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orUserNameGreaterThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`>'"+userName+"' ";
			}else{
				condition123 += "`user_name`>'"+userName+"' ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andUserNameLessThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`<'"+userName+"' ";
			}else{
				condition123 += "`user_name`<'"+userName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orUserNameLessThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`<'"+userName+"' ";
			}else{
				condition123 += "`user_name`<'"+userName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andUserNameGreadterThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`>='"+userName+"' ";
			}else{
				condition123 += "`user_name`>='"+userName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orUserNameGreadterThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`>='"+userName+"' ";
			}else{
				condition123 += "`user_name`>='"+userName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andUserNameLessThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`<='"+userName+"' ";
			}else{
				condition123 += "`user_name`<='"+userName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orUserNameLessThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`<='"+userName+"' ";
			}else{
				condition123 += "`user_name`<='"+userName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andUserNameLike(String userName){
		if(userName!=null&&userName.trim().length()>0&&!("%".equals(userName.trim()))&&!("%%".equals(userName.trim()))){
			if(condition123.length()>0){
				condition123 += "and `user_name` like '"+userName+"' ";
			}else{
				condition123 += "`user_name` like '"+userName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orUserNameLike(String userName){
		if(userName!=null&&userName.trim().length()>0&&!("%".equals(userName.trim()))&&!("%%".equals(userName.trim()))){
			if(condition123.length()>0){
				condition123 += "or `user_name` like '"+userName+"' ";
			}else{
				condition123 += "`user_name` like '"+userName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andUserNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `user_name` is null";
			}else{
				condition123 += "`user_name` is null";
			}
		return this;
	}
	public BackUserCriteria orUserNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `user_name` is null";
		}else{
			condition123 += "`user_name` is null";
		}
		return this;
	}
	public BackUserCriteria andUserNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `user_name` is not null";
		}else{
			condition123 += "`user_name` is not null";
		}
		return this;
	}
	public BackUserCriteria orUserNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `user_name` is not null";
		}else{
			condition123 += "`user_name` is not null";
		}
		return this;
	}
	
	public BackUserCriteria andUserNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `user_name` in("+value+") ";
			}else{
				condition123 += "`user_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orUserNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `user_name` in("+value+") ";
			}else{
				condition123 += "`user_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andUserNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `user_name` not in("+value+") ";
			}else{
				condition123 += "`user_name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orUserNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `user_name` not in("+value+") ";
			}else{
				condition123 += "`user_name` not in("+value+") ";
			}
		}
		return this;
	}

	public BackUserCriteria andPasswordEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`='"+password+"' ";
			}else{
				condition123 += "`password`='"+password+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orPasswordEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`='"+password+"' ";
			}else{
				condition123 += "`password`='"+password+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andPasswordNotEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`!='"+password+"' ";
			}else{
				condition123 += "`password`!='"+password+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orPasswordNotEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`!='"+password+"' ";
			}else{
				condition123 += "`password`!='"+password+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andPasswordGreaterThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`>'"+password+"' ";
			}else{
				condition123 += "`password`>'"+password+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orPasswordGreaterThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`>'"+password+"' ";
			}else{
				condition123 += "`password`>'"+password+"' ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andPasswordLessThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`<'"+password+"' ";
			}else{
				condition123 += "`password`<'"+password+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orPasswordLessThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`<'"+password+"' ";
			}else{
				condition123 += "`password`<'"+password+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andPasswordGreadterThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`>='"+password+"' ";
			}else{
				condition123 += "`password`>='"+password+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orPasswordGreadterThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`>='"+password+"' ";
			}else{
				condition123 += "`password`>='"+password+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andPasswordLessThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`<='"+password+"' ";
			}else{
				condition123 += "`password`<='"+password+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orPasswordLessThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`<='"+password+"' ";
			}else{
				condition123 += "`password`<='"+password+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andPasswordLike(String password){
		if(password!=null&&password.trim().length()>0&&!("%".equals(password.trim()))&&!("%%".equals(password.trim()))){
			if(condition123.length()>0){
				condition123 += "and `password` like '"+password+"' ";
			}else{
				condition123 += "`password` like '"+password+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orPasswordLike(String password){
		if(password!=null&&password.trim().length()>0&&!("%".equals(password.trim()))&&!("%%".equals(password.trim()))){
			if(condition123.length()>0){
				condition123 += "or `password` like '"+password+"' ";
			}else{
				condition123 += "`password` like '"+password+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andPasswordIsNull(){
			if(condition123.length()>0){
				condition123 += "and `password` is null";
			}else{
				condition123 += "`password` is null";
			}
		return this;
	}
	public BackUserCriteria orPasswordIsNull(){
		if(condition123.length()>0){
			condition123 += "or `password` is null";
		}else{
			condition123 += "`password` is null";
		}
		return this;
	}
	public BackUserCriteria andPasswordIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `password` is not null";
		}else{
			condition123 += "`password` is not null";
		}
		return this;
	}
	public BackUserCriteria orPasswordIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `password` is not null";
		}else{
			condition123 += "`password` is not null";
		}
		return this;
	}
	
	public BackUserCriteria andPasswordIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `password` in("+value+") ";
			}else{
				condition123 += "`password` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orPasswordIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `password` in("+value+") ";
			}else{
				condition123 += "`password` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andPasswordNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `password` not in("+value+") ";
			}else{
				condition123 += "`password` not in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orPasswordNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `password` not in("+value+") ";
			}else{
				condition123 += "`password` not in("+value+") ";
			}
		}
		return this;
	}

	public BackUserCriteria andNickNameEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orNickNameEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNickNameNotEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`!='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`!='"+nickName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNickNameNotEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`!='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`!='"+nickName+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andNickNameGreaterThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`>'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>'"+nickName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNickNameGreaterThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`>'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>'"+nickName+"' ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andNickNameLessThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`<'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<'"+nickName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNickNameLessThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`<'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<'"+nickName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNickNameGreadterThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`>='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>='"+nickName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNickNameGreadterThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`>='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNickNameLessThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`<='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<='"+nickName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNickNameLessThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`<='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNickNameLike(String nickName){
		if(nickName!=null&&nickName.trim().length()>0&&!("%".equals(nickName.trim()))&&!("%%".equals(nickName.trim()))){
			if(condition123.length()>0){
				condition123 += "and `nick_name` like '"+nickName+"' ";
			}else{
				condition123 += "`nick_name` like '"+nickName+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNickNameLike(String nickName){
		if(nickName!=null&&nickName.trim().length()>0&&!("%".equals(nickName.trim()))&&!("%%".equals(nickName.trim()))){
			if(condition123.length()>0){
				condition123 += "or `nick_name` like '"+nickName+"' ";
			}else{
				condition123 += "`nick_name` like '"+nickName+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNickNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `nick_name` is null";
			}else{
				condition123 += "`nick_name` is null";
			}
		return this;
	}
	public BackUserCriteria orNickNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `nick_name` is null";
		}else{
			condition123 += "`nick_name` is null";
		}
		return this;
	}
	public BackUserCriteria andNickNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `nick_name` is not null";
		}else{
			condition123 += "`nick_name` is not null";
		}
		return this;
	}
	public BackUserCriteria orNickNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `nick_name` is not null";
		}else{
			condition123 += "`nick_name` is not null";
		}
		return this;
	}
	
	public BackUserCriteria andNickNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `nick_name` in("+value+") ";
			}else{
				condition123 += "`nick_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orNickNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `nick_name` in("+value+") ";
			}else{
				condition123 += "`nick_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNickNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `nick_name` not in("+value+") ";
			}else{
				condition123 += "`nick_name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orNickNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `nick_name` not in("+value+") ";
			}else{
				condition123 += "`nick_name` not in("+value+") ";
			}
		}
		return this;
	}

	public BackUserCriteria andNameEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`='"+name+"' ";
			}else{
				condition123 += "`name`='"+name+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orNameEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`='"+name+"' ";
			}else{
				condition123 += "`name`='"+name+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNameNotEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`!='"+name+"' ";
			}else{
				condition123 += "`name`!='"+name+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNameNotEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`!='"+name+"' ";
			}else{
				condition123 += "`name`!='"+name+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andNameGreaterThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`>'"+name+"' ";
			}else{
				condition123 += "`name`>'"+name+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNameGreaterThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`>'"+name+"' ";
			}else{
				condition123 += "`name`>'"+name+"' ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andNameLessThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`<'"+name+"' ";
			}else{
				condition123 += "`name`<'"+name+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNameLessThan(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`<'"+name+"' ";
			}else{
				condition123 += "`name`<'"+name+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNameGreadterThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`>='"+name+"' ";
			}else{
				condition123 += "`name`>='"+name+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNameGreadterThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`>='"+name+"' ";
			}else{
				condition123 += "`name`>='"+name+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNameLessThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `name`<='"+name+"' ";
			}else{
				condition123 += "`name`<='"+name+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNameLessThanAndEquals(String name){
		if(name!=null&&name.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `name`<='"+name+"' ";
			}else{
				condition123 += "`name`<='"+name+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNameLike(String name){
		if(name!=null&&name.trim().length()>0&&!("%".equals(name.trim()))&&!("%%".equals(name.trim()))){
			if(condition123.length()>0){
				condition123 += "and `name` like '"+name+"' ";
			}else{
				condition123 += "`name` like '"+name+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orNameLike(String name){
		if(name!=null&&name.trim().length()>0&&!("%".equals(name.trim()))&&!("%%".equals(name.trim()))){
			if(condition123.length()>0){
				condition123 += "or `name` like '"+name+"' ";
			}else{
				condition123 += "`name` like '"+name+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `name` is null";
			}else{
				condition123 += "`name` is null";
			}
		return this;
	}
	public BackUserCriteria orNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `name` is null";
		}else{
			condition123 += "`name` is null";
		}
		return this;
	}
	public BackUserCriteria andNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `name` is not null";
		}else{
			condition123 += "`name` is not null";
		}
		return this;
	}
	public BackUserCriteria orNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `name` is not null";
		}else{
			condition123 += "`name` is not null";
		}
		return this;
	}
	
	public BackUserCriteria andNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `name` in("+value+") ";
			}else{
				condition123 += "`name` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `name` in("+value+") ";
			}else{
				condition123 += "`name` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `name` not in("+value+") ";
			}else{
				condition123 += "`name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `name` not in("+value+") ";
			}else{
				condition123 += "`name` not in("+value+") ";
			}
		}
		return this;
	}

	public BackUserCriteria andCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "and `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "or `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `create_date` is null";
			}else{
				condition123 += "`create_date` is null";
			}
		return this;
	}
	public BackUserCriteria orCreateDateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is null";
		}else{
			condition123 += "`create_date` is null";
		}
		return this;
	}
	public BackUserCriteria andCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	public BackUserCriteria orCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}

	public BackUserCriteria andStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public BackUserCriteria andStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	
	
	public BackUserCriteria andStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "and `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	public BackUserCriteria orStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "or `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andStateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `state` is null";
			}else{
				condition123 += "`state` is null";
			}
		return this;
	}
	public BackUserCriteria orStateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is null";
		}else{
			condition123 += "`state` is null";
		}
		return this;
	}
	public BackUserCriteria andStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	public BackUserCriteria orStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	
	public BackUserCriteria andStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria andStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}
	
	public BackUserCriteria orStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}

	private void initBackUser(BackUser backUser) {
		super.setId(backUser.getId());
		super.setUserName(backUser.getUserName());
		super.setPassword(backUser.getPassword());
		super.setNickName(backUser.getNickName());
		super.setName(backUser.getName());
		super.setCreateDate(backUser.getCreateDate());
		super.setState(backUser.getState());

	}

}